drop table jms_dm.dm_end_dispatch_cheat_swip_sum_dt

CREATE EXTERNAL TABLE jms_dm.dm_end_dispatch_cheat_swip_sum_dt(
sign_time timestamp COMMENT '签收时间',
dispatch_agent_code string COMMENT '派件代理区code',
dispatch_agent_name string COMMENT '派件代理区',
sign_network_code string COMMENT '签收网点code',
sign_network_name string COMMENT '签收网点名称',
sign_agent_code string COMMENT '签收代理区编码',
sign_agent_name string COMMENT '签收代理区',
receiver_mobile_phone string COMMENT '收件人手机号',
mobile_phone_bf_trd string COMMENT '手机人手机号前三位',
mobile_phone_lst_fth string COMMENT '手机人手机号后四位',
disp_swip_cnt int COMMENT '派件刷单票数')
COMMENT '异常件-派件刷单汇总表'
PARTITIONED BY (dt string COMMENT '数据日期')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_end_dispatch_cheat_swip_sum_dt'
TBLPROPERTIES (
'discover.partitions' = 'false',
'parquet.column.index.access' = 'true'
);
